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