UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'q+QGqS3e9qLml1RnfsXCgveV3trrs91VHMu7d1R3wa8='
WHERE
key_id = 'a3c8cc199894bf2ff1cdac1357459055008b8f5d29a375bbdc5dd6296471fafc'
AND (
token = 'q+QGqS3e9qLml1RnfsXCgveV3trrs91VHMu7d1R3wa8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)