UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'RUnhVcDH9qOt1L9kxCXb3dnhybjMoOyG8TfCQ2Jv4tE='
WHERE
key_id = '8bd1448955077f09941018b041d8b1565780c326985593adfc8b3e53f0a3a083'
AND (
token = 'RUnhVcDH9qOt1L9kxCXb3dnhybjMoOyG8TfCQ2Jv4tE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)