UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HqcTy3DUjKAcoPuhOSPcp47FMNigxgD/8GgWNiqC9U8='
WHERE
key_id = 'eb76938759140d71c7eb49066d3826faf274ce41a04b1034cfe5d00b9719510e'
AND (
token = 'HqcTy3DUjKAcoPuhOSPcp47FMNigxgD/8GgWNiqC9U8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)