UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Ys5QmSA705cQmV4hQXS8zpckeXojuVD6MECwL4i972I='
WHERE
key_id = 'a2dc013c4905e46bdb57cbb2b8b6b0f7428da32ed64b3f5440f4464876df5e06'
AND (
token = 'Ys5QmSA705cQmV4hQXS8zpckeXojuVD6MECwL4i972I='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)