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