UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hrNt0XuM7JChfaeG2l/8m7dxbiKcVOStGSrulTciA/k='
WHERE
key_id = 'ae47c79093be399e4d9df5e5c1fff6319c954608edc774f05811d013af59438e'
AND (
token = 'hrNt0XuM7JChfaeG2l/8m7dxbiKcVOStGSrulTciA/k='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)